Cutting-edge content and guidance from a data warehousing expert--now expanded to reflect field trends

Data warehousing has revolutionized the way businesses in a wide variety of industries perform analysis and make strategic decisions. Since the first edition of "Data Warehousing Fundamentals," numerous enterprises have implemented data warehouse systems and reaped enormous benefits. Many more are in the process of doing so. Now, this new, revised edition covers the essential fundamentals of data warehousing and business intelligence as well as significant recent trends in the field.

The author provides an enhanced, comprehensive overview of data warehousing together with in-depth explanations of critical issues in planning, design, deployment, and ongoing maintenance. IT professionals eager to get into the field will gain a clear understanding of techniques for data extraction from source systems, data cleansing, data transformations, data warehouse architecture and infrastructure, and the various methods for information delivery.

This practical "Second Edition" highlights the areas of data warehousing and business intelligence where high-impact technological progress has been made. Discussions on developments include data marts, real-time information delivery, data visualization, requirements gathering methods, multi-tier architecture, OLAP applications, Web clickstream analysis, data warehouse appliances, and data mining techniques. The book also contains review questions and exercises for each chapter, appropriate for self-study or classroom work, industry examples of real-world situations, and several appendices with valuable information.

Specifically written for professionals responsible for designing, implementing, or maintaining data warehousing systems, "Data Warehousing Fundamentals" presents agile, thorough, and systematic development principles for the IT professional and anyone working or researching in information management.

A ONE-STOP, DEFINITIVE GUIDE TO DATA MODELING FOR IT PROFESSIONALS

Data Modeling Fundamentals is a comprehensive guide to the foundation and principles behind data modeling and its essential role in successful database design. The only book specifically addressing the essentials of data modeling for IT professionals, it includes:

An overview of data modeling concepts, techniques, and symbols

Anatomy of a comprehensive data model describing the various components

Extensive details of entities, attributes, identifiers, and relationships

Transition from data modeling to database design and implementation, datanormalization, and modeling for decision-support systems

Quality data modeling and agile data modeling in practice

Trends in data modeling methodologies and techniques

Chapter summaries with review questions and exercises at the conclusion of each chapter help readers gauge their understanding of the material presented. Complete with real-world examples, references, and an abundance of practical tips and suggestions, Data Modeling Fundamentals is an indispensable resource for both novice and experienced data modelers.

The first and only database primer for today’s global economy

Today’s businesses depend on their databases to provide information essential for their day-to-day operations and to help them take advantage of today’s rapidly growing and maturing electronic commerce opportunities. The primary responsibility for the design and maintenance of these databases rests with a company’s information technology department.

Unlike other IT resources currently available that tend to focus on a particular product, Database Design and Development: An Essential Guide for IT Professionals was created to give today’s IT directors and other IT staff a solid basic knowledge of database design and development to help them make educated decisions about the right database environment for their companies. Today’s IT professionals must understand the fundamentals in order to determine their next steps for specializing in the vast field of database technology.

Database Design and Development: An Essential Guide for IT Professionals answers such common questions as:

• What is the purpose of a database system?
• What are the components of a database system?
• What type of data does your company need to capture?
• How do you design a database for a particular goal?
• How do you capture information through data modeling?
• How do you determine which database will best meet your business objectives?
• What’s involved in effective database management and maintenance?
• How are database systems used to interface with the Internet?

With more than twenty-five years of experience teaching IT courses and designing databases for some of America’s top institutions, the author has succeeded in creating an essential resource for today’s IT managers as well as for students planning a career in information technology.